
using System;
using System.Collections.Generic;
using System.Text;
using System.IO;

namespace Test.Support {
	class NpmsRtfFix {

		static void MainX() {

			DAL dal=new DAL("pon-wpsq21-db07\\in07","npms");
			//dal.NonQry("create table stol(inserted datetime,ip varchar(15))");
			string[] lines=File.ReadAllLines("C:\\rtf.txt");
			foreach(string line in lines)
			{
				Console.WriteLine("select RTFStatusID from rtf where ID in({0})",line);
				//Console.WriteLine(dal.Scalar(s1));
				Console.WriteLine("select count(*) from Missions where RTFID in({0})--no missions",line);

				//Console.WriteLine(dal.Scalar(s2));
				Console.WriteLine("exec spUpdateRTFStatus {0},9",line);
			}



			/*

			select RTFStatusID, * from rtf where ID in (2553106,2556212)

select  * from Missions where RTFID in (2553106,2556212)

exec spDeleteMission 1267734
exec spDeleteMission 1275215

exec spUpdateRTFStatus 2553106, 9
exec spUpdateRTFStatus 2556212, 9

			*/





		}
	}
}
